package org.soft.carbon_neutral.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.soft.carbon_neutral.entity.EquipmentValue;
import org.soft.carbon_neutral.vo.EquipmentValueVO;

import java.util.List;

@Mapper
public interface EquipmentValueMapper extends BaseMapper<EquipmentValue> {

    @Select("SELECT DISTINCT e.id,e.threshold,v.concentration,v.create_time,v.type FROM `equipment_value` as v,`equipment` as e where v.id=e.id;")
    List<EquipmentValueVO> getEquipmentValueList();
}
